The EDB Postgres Advanced Server must separate user functionality (including user interface services) from database management functionality.

Overview

Finding ID	Version	Rule ID	IA Controls	Severity
V-259257	EPAS-00-005100	SV-259257r938824_rule		Medium

Description
Information system management functionality includes functions necessary to administer databases, network components, workstations, or servers and typically requires privileged user access. The separation of user functionality from information system management functionality is either physical or logical and is accomplished by using different computers, different central processing units, different instances of the operating system, different network addresses, combinations of these methods, or other methods, as appropriate. An example of this type of separation is observed in web administrative interfaces that use separate authentication methods for users of any other information system resources. This may include isolating the administrative interface on a different domain and with additional access controls. If administrative functionality or information regarding DBMS management is presented on an interface available for users, information on DBMS settings may be inadvertently made available to the user.

Description

Information system management functionality includes functions necessary to administer databases, network components, workstations, or servers and typically requires privileged user access. The separation of user functionality from information system management functionality is either physical or logical and is accomplished by using different computers, different central processing units, different instances of the operating system, different network addresses, combinations of these methods, or other methods, as appropriate. An example of this type of separation is observed in web administrative interfaces that use separate authentication methods for users of any other information system resources. This may include isolating the administrative interface on a different domain and with additional access controls. If administrative functionality or information regarding DBMS management is presented on an interface available for users, information on DBMS settings may be inadvertently made available to the user.

STIG	Date
EnterpriseDB Postgres Advanced Server (EPAS) Security Technical Implementation Guide	2023-11-20

Details

Check Text ( C-62996r938822_chk )
As the "enterprisedb" user, run the following from the command line: > psql edb From the psql prompt run: \du If a user listed in the output is not approved for SUPERUSER access, this is a finding.

Fix Text (F-62905r938823_fix)
Execute the following SQL as the "enterprisedb" operating system user for all database users not approved for SUPERUSER privileges: > psql edb -c "ALTER USER NOSUPERUSER"